+ Reply to Thread
Results 1 to 3 of 3

VLOOKUP OR PROCV - problem

  1. 02-19-2020, 08:58 AM #1
    agafur
    agafur is offline
    Registered User
    Join Date
    02-19-2020
    Location
    matola/ mozambique
    MS-Off Ver
    professional plus 2013
    Posts
    1

    VLOOKUP OR PROCV - problem

    Good Afternoon

    I have a problem on my workbook sheet.

    i need to that my cel b4 give me back automatic answer about the details according to Cel 4
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 02-19-2020, 09:01 AM #2
    Pepe Le Mokko
    Pepe Le Mokko is offline
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,453

    Re: VLOOKUP OR PROCV - problem

    Perahps =INDEX($B$16:$B$19,MATCH($C4,$C$16:$C$19,0))
    How to paste Power Query code ( by Olly)
    Reply With QuoteRegister To Reply
  3. 02-19-2020, 09:02 AM #3
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2405 (Windows 11 23H2 64-bit)
    Posts
    81,417

    Re: VLOOKUP OR PROCV - problem

    Welcome to the forum.

    In B4:

    =IFERROR(INDEX(Tabela68[[#All],[Matricula]],MATCH([@[Nş Veiculo]],Tabela68[[#All],[Nş Veiculo]],0)),"")

    You may need to change commas to semi-colons for your locale.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] If statment and procv issue
    By distraido in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-24-2016, 05:42 PM
  2. [SOLVED] Using PROCV and PROCH in the same formula wirth referenced cells
    By bbordeira in forum Excel General
    Replies: 1
    Last Post: 04-11-2016, 10:19 AM
  3. [SOLVED] which formula should I use? PROCV or SOMASE or another..
    By stazevedo in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-29-2015, 10:26 AM
  4. Function PROCV with 2 references HELP
    By hallaw81 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-23-2014, 01:08 PM
  5. Index / Match / Vlookup type problem - £20 to person who solves this! X ref problem
    By aceparts in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-28-2013, 05:08 PM
  6. SE and PROCV
    By Birnen in forum Non English Excel
    Replies: 7
    Last Post: 08-12-2010, 12:35 PM
  7. some small ajustment...in procv function.
    By x-plicit in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-26-2010, 09:43 AM

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1