Lookup

[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

 

[Lance]

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

 

[dvt]

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

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