Vlookup in another sheet which involves an mathematical calculation and IF function

**haroun** · 02-18-2013, 06:27 PM

Hello ,

I am trying to figure out a formula that can lookup a number in Sheet 2, do an mathematical calculation and return me a 'Yes' or 'No' based on the answer of the calculation.

The attached sheet clarifies it further.

Thanks in advance for your help.
Haroun

**Special-K** · 02-18-2013, 06:46 PM

If your data in Sheet 2 column B was in order you could use VLOOKUP.
It's not so we have to use this instead

in Sheet 1!D2
=IF((INDEX('Sheet 2'!E$2:E$5,(MATCH(A2,'Sheet 2'!B$2:B$5,0)),1)-2)/INDEX('Sheet 2'!D$2:D$5,(MATCH(A2,'Sheet 2'!B$2:B$5,0)),1)<3,"Yes","No")

and copy down

**protonLeah** · 02-18-2013, 06:47 PM

here's an example:

**haroun** · 03-05-2013, 03:42 PM

Thanks alot Special-K. thats exactly what i needed.

Vlookup in another sheet which involves an mathematical calculation and IF function

LinkBack

Thread Tools

Rate This Thread

Display

Vlookup in another sheet which involves an mathematical calculation and IF function

Re: Vlookup in another sheet which involves an mathematical calculation and IF function

Re: Vlookup in another sheet which involves an mathematical calculation and IF function

Re: Vlookup in another sheet which involves an mathematical calculation and IF function

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions