Previous Topic Next Topic

VLOOKUP Help

Closed
mb4822 - May 20, 2010 at 11:21 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 21, 2010 at 05:46 AM
Hello,

I am trying to figure out how to use the VLOOKUP for table array in a spreadsheet.

Here is my data

EU US SL AD ROW
Custom Engineering £315 £315 £65 £277 £160
Testing £260 £260 £65 £277 £160
Deployment Services £330 £330 £65 £277 £160
Technical Project Management £450 £450 £140 £277 £210
Solution Services £475 £475 £140 £277 £220
Training £450 £450 £65 £277 £210
Leadership £550 £615 £170 £277 £250
Support £290 £405 £65 £277 £160

I want to lookup "Custom Engineering" in the US and return the result £315

Can someone help with this formula??

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 21, 2010 at 05:46 AM
VLOOKUP(A2, A:F, 3, FALSE)

It says look at the value in A2 and match it in column A ( that comes from A:F part) and return me the value found in 3 column of range A:F. False is saying that I was exact match
0

Similar discussions

Comparing columns and returning value
ll -
kittu -

35 responses
Match partial text string in one sheet to another text string in another sheet
Santos -
Santos -

2 responses
Lookup partial text contained in cell range
Tom -
Tom -

4 responses
Using Vlookup to return insted of 00/01/1900
Tom9o -
tom9o -

2 responses
add/subtract & vlookup formula
sudhir -
sudhir -

2 responses