I'm trying to set up a report that based on the input into one static cell on
Tab A it will search Tab B column A for the exact match and then pull in the
text from column B.

For example...

Tab A, cell H40 =12

Tab B, cell A15 =12 and cell B15 contains the text I won't pulled into Tab A
cell c62

I know this should be simple and Excel can make breakfast for you if you
know program it to do so, but I'm stumped! Any ideas?

Thanks in advance for your assistance!
--
nicole

Say your reference cell is A1 on Tab A and your range of lookup values and
text is B1:C45. Type (or copy) this formula into the cell you want your
answer displayed.

=VLOOKUP('Tab A'!A1,'Tab B'!A1:B45,2)

This will look up the value in A1 on table A1:B45 and return the
corresponding value from column B. The table A1:B45 must be sorted in
ascending order for the funciton to work.

Note that 'Tab A'! and 'Tab B'! are the sheet references. You don't need
them unless your formula is on a different sheet (for instance, if your
formula is on Tab A and your lookup table is on Tab B you would use

=VLOOKUP(A1,'Tab B'!A1:B45,2)
--
HTH

JonR


"nicole" wrote:

I'm trying to set up a report that based on the input into one static cell on
Tab A it will search Tab B column A for the exact match and then pull in the
text from column B.

For example...

Tab A, cell H40 =12

Tab B, cell A15 =12 and cell B15 contains the text I won't pulled into Tab A
cell c62

I know this should be simple and Excel can make breakfast for you if you
know program it to do so, but I'm stumped! Any ideas?

Thanks in advance for your assistance!
--
nicole

Thanks Jon. I think I tried to overcomplicate the issue!
--
nicole


"JonR" wrote:

Say your reference cell is A1 on Tab A and your range of lookup values and
text is B1:C45. Type (or copy) this formula into the cell you want your
answer displayed.

=VLOOKUP('Tab A'!A1,'Tab B'!A1:B45,2)

This will look up the value in A1 on table A1:B45 and return the
corresponding value from column B. The table A1:B45 must be sorted in
ascending order for the funciton to work.

Note that 'Tab A'! and 'Tab B'! are the sheet references. You don't need
them unless your formula is on a different sheet (for instance, if your
formula is on Tab A and your lookup table is on Tab B you would use

=VLOOKUP(A1,'Tab B'!A1:B45,2)
--
HTH

JonR


"nicole" wrote:

I'm trying to set up a report that based on the input into one static cell on
Tab A it will search Tab B column A for the exact match and then pull in the
text from column B.

For example...

Tab A, cell H40 =12

Tab B, cell A15 =12 and cell B15 contains the text I won't pulled into Tab A
cell c62

I know this should be simple and Excel can make breakfast for you if you
know program it to do so, but I'm stumped! Any ideas?

Thanks in advance for your assistance!
--
nicole