Is this formula looking all over sheet.

G

ghrek

Active Member
Joined
Jul 29, 2005
Messages
426
Hi

I have this formula in a workbook and asking if its looking all the way down as im getting OK from some stuff that is not in the tab called Watford

=IFNA(IF(E466=VLOOKUP(A466,WATFORD!A:E,5,),"OK","N/A"),"N/A")

Thanks
 

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)
Sort by date Sort by votes
Try adding False (or 0) as the last parameter in your lookup.
Excel Formula: 
=IFNA(IF(E466=VLOOKUP(A466,WATFORD!A:E,5, FALSE),"OK","N/A"),"N/A")
 
Upvote 0
Solution
You must log in or register to reply here.

Similar threads

G
  • Solved
How do I add to a formula to include duplicated entries
Replies
3
Views
228
etaf
etaf
P
  • Solved
Transferring data between two userforms problem .
Replies
7
Views
299
Pacman52
P
C
  • Question
Delete Cell Range, or Add Range and Copy Formulas etc. - Excel VBA
Replies
0
Views
73
CSTjr
C
J
  • Question
Pulling Data from non adjacent columns for display on OverView Sheet
Replies
0
Views
120
Jaypee666
J
F
  • Question
Filtering/Copying a table via VBA.
Replies
2
Views
124
frobeniusabnorm
F

Forum statistics

Threads
1,215,077
Messages
6,122,991
Members
449,094
Latest member
masterms

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top