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

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

2 responses
Compare values in two columns and return the value from third
ramdubai -
keshav -

11 responses
Concanating text using vlookup forumula
gannesh0604 -
gannesh0604 -

0 responses
Conditional Formatting in a vlookup
attycuz -
TrowaD -

1 response
Find missing data in 2 columns (Excel)
dalami81 -
dalami81 -

2 responses