# Excel 2007 : Use VLOOKUP to then populate another cell with IF statement

1. ## Use VLOOKUP to then populate another cell with IF statement

Hello, So I am new to using excel.

I am pulling a value from another excel file using VLOOKUP, that can be anywhere from 1 to 6,000.

Then Based off the value pulled for example let's say it's: 4,227 in cell A1

I want to use and IF statement to populate another value in a different cell. I am currently using:

It only outputs: 0

Am I using the formula incorrectly? Do I have to attack this a different way? Thanks for any help.

2. ## Re: Use VLOOKUP to then populate another cell with IF statement

Firstly you need to remove all the = and ". But there is something wrong with the logic I think. Could you put your =IF() statements into words?

3. ## Re: Use VLOOKUP to then populate another cell with IF statement

Assuming whole numbers from 0 on could be in A1

Try:

=LOOKUP(A1,{0,501,1001,2001,4001},{5,10,25,30,40})

4. ## Re: Use VLOOKUP to then populate another cell with IF statement

Yeah only whole numbers from 0 on could be in A1.

I gave it a try and it comes up: #N/A

5. ## Re: Use VLOOKUP to then populate another cell with IF statement

=LOOKUP(A1+0,{0,501,1001,2001,4001},{5,10,25,30,40})

#Value Error

7. ## Re: Use VLOOKUP to then populate another cell with IF statement

No! I rearranged some stuff & that works perfect!!! Thanks so much NBVC!!! Your Awesome!

8. ## Re: Use VLOOKUP to then populate another cell with IF statement

Are you sure there is a number in A1?

Edit... okay saw your last postt...all is good

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1