Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have 144 unique data fields in cells B5:B148. Each of these data fields is
individually located somewhere (not in order) in cells K5:AH148. What I want to do is in C5, find the value in B5 somewhere in the K5:AH148 range, and return the value in the very next column to the right. For instance, the matching B5 data could be in cell S57 for example, and I'd want to display the data in T57 in cell C5. Any idea as to how to do this? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to sum multiple matches to a vlookup command | Excel Worksheet Functions | |||
Vlookup command not giving the correct result | Excel Worksheet Functions | |||
VLOOKUP JUST RETURNS THE TEXT OF THE COMMAND | Excel Worksheet Functions | |||
using a vlookup command in a for next loop in a macro in excel | Excel Discussion (Misc queries) | |||
Using the VLOOKUP Command | Excel Worksheet Functions |