# 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

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

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