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

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
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
256
etaf
etaf
P
  • Solved
VLOOKUP (or VBA Alternative?) From another workbook, depending on Financial Year
Replies
2
Views
100
paun_shotts
P
P
  • Solved
Transferring data between two userforms problem .
Replies
7
Views
348
Pacman52
P
C
  • Question
Delete Cell Range, or Add Range and Copy Formulas etc. - Excel VBA
Replies
0
Views
138
CSTjr
C
J
  • Question
Pulling Data from non adjacent columns for display on OverView Sheet
Replies
0
Views
136
Jaypee666
J

Forum statistics

Threads
1,216,046
Messages
6,128,489
Members
449,455
Latest member
jesski

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