Vlookup

[Bellen]

How do you solve the following;

If the range_lookup argument is FALSE, VLOOKUP will find only an exact match. If there are two or more values in the first column of table_array that match the lookup_value, the first value found is used. If an exact match is not found, the error value #N/A is returned.

For example if I would like the function to read from something called TX1, TX2, TX3 and TX4, and then I add TX up to TX14, then the function will read 14 as 1 (the first digit in the number).

[NBVC]

You need different formulas to solve for multiple matches...

... please submit an example file and what you want to lookup and return.

[Bellen]

Attached....

You need different formulas to solve for multiple matches...

... please submit an example file and what you want to lookup and return.

[NBVC]

You only have one match in the table in the Time Boxes sheet.

What are your expected results?

[Bellen]

To when changing the TX number in the Project Plan column Time box that the dates in the next right column should change according to Tab Time Boxes and return same value.

You only have one match in the table in the Time Boxes sheet.

What are your expected results?

[NBVC]

Maybe we are not on the same page...

Are you going to have repeat items in Column B of the Time Boxes sheet?

That is when you will need to know if you need to pick up multiple items...

Maybe you want to use this formula instead:

=VLOOKUP(I3,'Time boxes'!$B$3:$C$9,2,0)

which returns an exact match... perhaps your issue was it wasn't returning an exact match???

[Bellen]

Hi, I would like for the function to return an exact match Yes, but the formula I got yesterday did not work. I would like to when I am typing for example an A the function to return a certain date which is show in the other Tab, but since VLLOKUP only return first value i.e for numer 14, it returns '1' instead of both 1 and 4 it does not work for bigger numbers.

[NBVC]

Huh?

Maybe you should re-post your spreadsheet and show me an example of what you mean?

Where will you input and what do you expect to be the outcome?

[WHER]

Bellen,

Maybe your problem is this part of the Vlookup formula (sheet Project plan J3 and down):
Time boxes'!$B$3:$C$9
That range seems to be to small to look for TX14, since TX14 is found in cell B16 of sheet Time boxes.
Or did i just add to the confusion?