CODEWITHSUNDEEP
google-sheets
Rich Davis
Rich Davis

Reputation: 118

Simple HLOOKUP not working,

This one stumps me, I simply want to return the "BG" of whichever column has the key.

My formula:

HLOOKUP(E1, B2:D12, 1, FALSE)

Should give me BG1 here!

Does anyone know why this isn't working properly?

enter image description here

Upvotes: 2

Views: 847

Answers (1)

J. Chomel
J. Chomel

Reputation: 8395

I know why: HLOOKUP is looking in the first row.

So you must get you "BG" labels at the bottom of your table.

With 

   \ B                 C       D  
2    TheLivingTribunal NowTime smthg
3    a                 b       c
4    BG1               BG2     BG3

Then use column 3:

hLOOKUP(E1, B2:D4, 3, FALSE)

will give BG1... not necessarily as practical as expected.

Upvotes: 1

Related Questions