HLOOKUP Help

[BuckNut614]

In the Rental Data worksheet, in column G, create a formula that uses the HLOOKUP function to assign a group code (A,B, C, D, or E) from the FurnitureGroups range in the Rental Information worksheet to the furniture listed in column B.

[Richard Buttrey]

Hi,

Try

Please Login or Register  to view this content.

Many of us prefer the INDEX(MATCH()) combination for lookups - which is necessary when the value being looked up isn;t in the first column/row of a lookup table

=INDEX('Rental Information'!$H$3:$P$3,MATCH([@Furniture],'Rental Information'!$H$2:$P$2,FALSE))

[TMS]

This

In the Rental Data worksheet, in column G, create a formula that uses the HLOOKUP function to assign a group code (A,B, C, D, or E) from the FurnitureGroups range in the Rental Information worksheet to the furniture listed in column B.

kinda looks/sounds like a homework task. I hope it's not as, if it is, you should be researching a solution and/or asking your tutor, not asking for the question to be answered for you.

You will lose out by not working it out for yourself.

Whatever:

Please Login or Register  to view this content.

[BuckNut614]

I got this one to work.
=HLOOKUP([@Furniture],FurnitureGroups,2,FALSE)

Now I need the following:

In column H, create a formula using the IF and VLOOKUP functions to calculate the rental charges for each set of furniture based on the furniture's group code, the rental period, and the Furniture Rental Charges Table.