Lookup based on two criteria in 1 row

[Guest]

Hi all,

In looking thru the help, I didn't find anything that looked quite like my
issue, though there were some similar. I have a table with 2 criteria in the
same row, and I am attempting to essentially graph my answers on a separate
sheet.

Data:
Group # Option # On/Off
(8) 1 On
(8) 2 Off
(14) 1 On
(14) 2 On

Ideal results:

" (8) (14)
1 On On
2 Off On

My actual data is obviously a much larger table, and I need this to be
something I can view all at once to print, etc. Normally, I would do a
vlookup to get myself one set of data on this, and I could manually run a
vlookup for each set of group #'s, but that's ugly and manual. I'm hoping
this is simpler then I'm making it.

Thanks all!
-beth

 

[Guest]

Well, I think I found it, even if it not the most graceful way to do this. I
inserted a fresh column #1 and concatenated my two values, and then plugged
in the "VLOOKUP(A2&B1,D1:H80,2,0)" formula I found referenced in another
question here on the board, and it worked out great.

TIA for any suggestions anyone was going to offer!

-beth

 

[CLR]

Good Girl!!!.......exactly what I was about to suggest, and then I saw your
second post.......it's great that you were able to figure it out for
yourself..........thats the fun part........

Vaya con Dios,
Chuck, CABGx3

 

[Guest]

Thanks!! The one thing that it didn't do was allow me to create the formula
once and populate the whole table. I created the original function in B2,
but I needed to lock my reference to my row (e.g.- $A$2) to copy it across
the tops of the columns, then edit each of those by unlocking the reference
to A2 and locking the column reference ($B$1, $C$1, etc.) to copy en masse
down the page. I more effective way of that might have simplified it, but it
got the job done!

-beth

-----------