hamspankin1
New member
Hi, is there a way that a Vlookup can return results from more than one cell? for example i have the following cells
A _______ B
123B____ 5
123B____ 8
124B____ 4
124B____ 3 and so on......
I need the lookup to search for "123A" and return the value 13 (column B 8+5). Any ideas anybody please
A _______ B
123B____ 5
123B____ 8
124B____ 4
124B____ 3 and so on......
I need the lookup to search for "123A" and return the value 13 (column B 8+5). Any ideas anybody please