Lookup

  • Thread starter Thread starter matt
  • Start date Start date
M

matt

Q103


Q102 Q202 Q302 Q402 Q103 Q203


How can I lookup the Q103 in the row above and then have
it pull the number to the right one cell (Q203)? thanks
 
If I understand correctly

=INDEX(A2:F2,MATCH(A1,A2:F2,0)+1)
where q103 is in a1
and q102-q203 is in a2-f2
Lance
 
matt said:
Q103


Q102 Q202 Q302 Q402 Q103 Q203


How can I lookup the Q103 in the row above and then have
it pull the number to the right one cell (Q203)? thanks
Click to expand...

Here's a brute force idea. Make your spreadsheet look like this:

Q103

Q102 Q202 Q302 Q402 Q103 Q203
Q202 Q302 Q402 Q103 Q203

Now you should be able to use HLOOKUP to look down one row. You may wish to
hide that second row.

Dave
dvt at psu dot edu
 
Back
Top