If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
matching values
I need to be able to look up a value from 1 cell in a
range of cells to find if there is a match and where the match is Can anybody help Thanks Donna |
#2
|
|||
|
|||
matching values
I need to be able to look up a value from 1 cell in a
range of cells to find if there is a match and where the match is The MATCH function returns "the position of an item in a range instead of the item itself". If the range of cells is B1:B??? and value to find is in A1, ="B"&MATCH(A1,B:B,0) returns the cell reference. If value is not found, you'll get #N/A. HTH, Andy |
Thread Tools | |
Display Modes | |
|
|