Hi,
You seem to have the makes of a Vlookup.
Are you after something like this
=IF(F6<5,1,IF(F6>5,(VLOOKUP(F6,DED!$A$1:$B$11,2,FALSE))))
VBA Noob
Hi,
You seem to have the makes of a Vlookup.
Are you after something like this
=IF(F6<5,1,IF(F6>5,(VLOOKUP(F6,DED!$A$1:$B$11,2,FALSE))))
VBA Noob
_________________________________________
![]()
![]()
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks