Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Match a value from a column in worksheet
I am attempting to match a value from a column in worksheet “A” with and insert the name associated with the value in the next column over. The value/name combinations are in worksheet “B”. This is the formula I have that works only for the first value. {=(IF(I5=('B'!$A$2:$A$100),('B'!$B$2:$B$100)))} This is an example of the data in the column Column I 118107MB 122221MB This is an example of the data in worksheet “B” Column A Column B 118107MB AAA 122221MB BBB -- WilliamVierra ------------------------------------------------------------------------ WilliamVierra's Profile: http://www.excelforum.com/member.php...o&userid=26107 View this thread: http://www.excelforum.com/showthread...hreadid=394381 |
#2
|
|||
|
|||
=VLOOKUP(I5,'B'!$A$2:$B$100,2,0)
WilliamVierra wrote: I am attempting to match a value from a column in worksheet “A” with and insert the name associated with the value in the next column over. The value/name combinations are in worksheet “B”. This is the formula I have that works only for the first value. {=(IF(I5=('B'!$A$2:$A$100),('B'!$B$2:$B$100)))} This is an example of the data in the column Column I 118107MB 122221MB This is an example of the data in worksheet “B” Column A Column B 118107MB AAA 122221MB BBB -- [1] The SumProduct function should implicitly coerce the truth values to their Excel numeric equivalents. [2] The lookup functions should have an optional argument for the return value, defaulting to #N/A in its absence. |
#3
|
|||
|
|||
Thanks Aladin, =VLOOKUP(I5,'Account Name'!$A$2:$B$100,2,0) Worked! I had tried VLOOKUP earlier and it failed due to my error in the formula. Thanks for taking the time to reply. -- WilliamVierra ------------------------------------------------------------------------ WilliamVierra's Profile: http://www.excelforum.com/member.php...o&userid=26107 View this thread: http://www.excelforum.com/showthread...hreadid=394381 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
column filtering to match identical numbers | Excel Discussion (Misc queries) | |||
Can I have different column widths in a worksheet? | Excel Worksheet Functions | |||
match and count words | Excel Worksheet Functions | |||
How to group similar column titles together???? | Excel Discussion (Misc queries) | |||
How can I sort an entire spreadsheet from a list | Excel Worksheet Functions |