ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to setup a look up table where the lookup_value comes from tw. (https://www.excelbanter.com/excel-discussion-misc-queries/23253-how-setup-look-up-table-where-lookup_value-comes-tw.html)

Booner

How to setup a look up table where the lookup_value comes from tw.
 
I am trying to get a look up table to work for a spread sheet but the
lookup_value needs to come from two columns. vlookup will only use the left
most column.

Alan Beban

Booner wrote:
I am trying to get a look up table to work for a spread sheet but the
lookup_value needs to come from two columns. vlookup will only use the left
most column.

You would be more likely to get responses if you were to post a sample
illustration, say the values in A1:D4, and indicate what you are trying
to do.

Alan Beban


All times are GMT +1. The time now is 05:51 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com